Overview

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	9,994
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.6 MiB
Average record size in memory	168.0 B

Variable types

Numeric	6
Text	6
DateTime	2
Categorical	7

Alerts

`Country` has constant value "United States"	Constant
`Category` is highly overall correlated with `Sub-Category`	High correlation
`Discount` is highly overall correlated with `Profit`	High correlation
`Postal Code` is highly overall correlated with `Region` and 1 other fields	High correlation
`Profit` is highly overall correlated with `Discount` and 1 other fields	High correlation
`Region` is highly overall correlated with `Postal Code` and 1 other fields	High correlation
`Sales` is highly overall correlated with `Profit`	High correlation
`State` is highly overall correlated with `Postal Code` and 1 other fields	High correlation
`Sub-Category` is highly overall correlated with `Category`	High correlation
`Row ID` is uniformly distributed	Uniform
`Row ID` has unique values	Unique
`Discount` has 4798 (48.0%) zeros	Zeros

Reproduction

Analysis started	2025-11-16 15:49:59.405956
Analysis finished	2025-11-16 15:50:14.508055
Duration	15.1 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

Row ID
Real number (ℝ)

Uniform Unique

Distinct	9994
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4997.5

Minimum	1
Maximum	9994
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	500.65
Q1	2499.25
median	4997.5
Q3	7495.75
95-th percentile	9494.35
Maximum	9994
Range	9993
Interquartile range (IQR)	4996.5

Descriptive statistics

Standard deviation	2885.1636
Coefficient of variation (CV)	0.57732139
Kurtosis	-1.2
Mean	4997.5
Median Absolute Deviation (MAD)	2498.5
Skewness	0
Sum	49945015
Variance	8324169.2
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
6666	1	< 0.1%
6659	1	< 0.1%
6660	1	< 0.1%
6661	1	< 0.1%
6662	1	< 0.1%
6663	1	< 0.1%
6664	1	< 0.1%
6665	1	< 0.1%
6667	1	< 0.1%
Other values (9984)	9984	99.9%

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
9994	1	< 0.1%
9993	1	< 0.1%
9992	1	< 0.1%
9991	1	< 0.1%
9990	1	< 0.1%
9989	1	< 0.1%
9988	1	< 0.1%
9987	1	< 0.1%
9986	1	< 0.1%
9985	1	< 0.1%

Order ID
Text

Distinct	5009
Distinct (%)	50.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	139,916
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2,538 ?
Unique (%)	25.4%

Sample

1st row	CA-2016-152156
2nd row	CA-2016-152156
3rd row	CA-2016-138688
4th row	US-2015-108966
5th row	US-2015-108966

Value	Count	Frequency (%)
ca-2017-100111	14	0.1%
ca-2017-157987	12	0.1%
ca-2016-165330	11	0.1%
us-2016-108504	11	0.1%
ca-2015-131338	10	0.1%
ca-2016-105732	10	0.1%
us-2015-126977	10	0.1%
us-2015-163433	9	0.1%
ca-2017-140949	9	0.1%
ca-2015-158421	9	0.1%
Other values (4999)	9889	98.9%

Most occurring characters

Value	Count	Frequency (%)
1	25510	18.2%
-	19988	14.3%
0	15492	11.1%
2	15381	11.0%
C	8308	5.9%
A	8308	5.9%
6	7904	5.6%
7	7438	5.3%
4	7400	5.3%
5	7338	5.2%
Other values (5)	16849	12.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	99940	71.4%
Dash Punctuation	19988	14.3%
Uppercase Letter	19988	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	25510	25.5%
0	15492	15.5%
2	15381	15.4%
6	7904	7.9%
7	7438	7.4%
4	7400	7.4%
5	7338	7.3%
3	5449	5.5%
8	4042	4.0%
9	3986	4.0%

Uppercase Letter

Value	Count	Frequency (%)
C	8308	41.6%
A	8308	41.6%
U	1686	8.4%
S	1686	8.4%

Dash Punctuation

Value	Count	Frequency (%)
-	19988	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119928	85.7%
Latin	19988	14.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	25510	21.3%
-	19988	16.7%
0	15492	12.9%
2	15381	12.8%
6	7904	6.6%
7	7438	6.2%
4	7400	6.2%
5	7338	6.1%
3	5449	4.5%
8	4042	3.4%

Latin

Value	Count	Frequency (%)
C	8308	41.6%
A	8308	41.6%
U	1686	8.4%
S	1686	8.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	139916	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	25510	18.2%
-	19988	14.3%
0	15492	11.1%
2	15381	11.0%
C	8308	5.9%
A	8308	5.9%
6	7904	5.6%
7	7438	5.3%
4	7400	5.3%
5	7338	5.2%
Other values (5)	16849	12.0%

Order Date
Date

Distinct	1237
Distinct (%)	12.4%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Minimum	2014-01-03 00:00:00
Maximum	2017-12-30 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Ship Date
Date

Distinct	1334
Distinct (%)	13.3%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Minimum	2014-01-07 00:00:00
Maximum	2018-01-05 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Ship Mode
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Standard Class	5968
Second Class	1945
First Class	1538
Same Day	543

Length

Max length	14
Median length	14
Mean length	12.823094
Min length	8

Characters and Unicode

Total characters	128,154
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Second Class
2nd row	Second Class
3rd row	Second Class
4th row	Standard Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	5968	59.7%
Second Class	1945	19.5%
First Class	1538	15.4%
Same Day	543	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	9451	47.3%
standard	5968	29.9%
second	1945	9.7%
first	1538	7.7%
same	543	2.7%
day	543	2.7%

Most occurring characters

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	98172	76.6%
Uppercase Letter	19988	15.6%
Space Separator	9994	7.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	22473	22.9%
s	20440	20.8%
d	13881	14.1%
l	9451	9.6%
n	7913	8.1%
r	7506	7.6%
t	7506	7.6%
e	2488	2.5%
c	1945	2.0%
o	1945	2.0%
Other values (3)	2624	2.7%

Uppercase Letter

Value	Count	Frequency (%)
C	9451	47.3%
S	8456	42.3%
F	1538	7.7%
D	543	2.7%

Space Separator

Value	Count	Frequency (%)
	9994	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	118160	92.2%
Common	9994	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	22473	19.0%
s	20440	17.3%
d	13881	11.7%
l	9451	8.0%
C	9451	8.0%
S	8456	7.2%
n	7913	6.7%
r	7506	6.4%
t	7506	6.4%
e	2488	2.1%
Other values (7)	8595	7.3%

Common

Value	Count	Frequency (%)
	9994	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	128154	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

Customer ID
Text

Distinct	793
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	79,952
Distinct characters	40
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	CG-12520
2nd row	CG-12520
3rd row	DV-13045
4th row	SO-20335
5th row	SO-20335

Value	Count	Frequency (%)
wb-21850	37	0.4%
ma-17560	34	0.3%
pp-18955	34	0.3%
jl-15835	34	0.3%
ck-12205	32	0.3%
sv-20365	32	0.3%
jd-15895	32	0.3%
eh-13765	32	0.3%
zc-21910	31	0.3%
ep-13915	31	0.3%
Other values (783)	9665	96.7%

Most occurring characters

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	49970	62.5%
Uppercase Letter	19945	24.9%
Dash Punctuation	9994	12.5%
Lowercase Letter	43	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	1798	9.0%
C	1725	8.6%
M	1712	8.6%
B	1642	8.2%
D	1296	6.5%
A	1227	6.2%
J	1134	5.7%
P	1105	5.5%
H	968	4.9%
K	932	4.7%
Other values (16)	6406	32.1%

Decimal Number

Value	Count	Frequency (%)
1	11915	23.8%
0	8532	17.1%
5	7865	15.7%
2	4682	9.4%
7	2931	5.9%
6	2909	5.8%
9	2904	5.8%
8	2818	5.6%
3	2779	5.6%
4	2635	5.3%

Lowercase Letter

Value	Count	Frequency (%)
p	29	67.4%
o	8	18.6%
l	6	14.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9994	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	59964	75.0%
Latin	19988	25.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	1798	9.0%
C	1725	8.6%
M	1712	8.6%
B	1642	8.2%
D	1296	6.5%
A	1227	6.1%
J	1134	5.7%
P	1105	5.5%
H	968	4.8%
K	932	4.7%
Other values (19)	6449	32.3%

Common

Value	Count	Frequency (%)
1	11915	19.9%
-	9994	16.7%
0	8532	14.2%
5	7865	13.1%
2	4682	7.8%
7	2931	4.9%
6	2909	4.9%
9	2904	4.8%
8	2818	4.7%
3	2779	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79952	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Customer Name
Text

Distinct	793
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Length

Max length	22
Median length	18
Mean length	12.960676
Min length	7

Characters and Unicode

Total characters	129,529
Distinct characters	57
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	Claire Gute
2nd row	Claire Gute
3rd row	Darrin Van Huff
4th row	Sean O'Donnell
5th row	Sean O'Donnell

Value	Count	Frequency (%)
michael	120	0.6%
frank	112	0.6%
john	107	0.5%
patrick	96	0.5%
brian	93	0.5%
stewart	93	0.5%
paul	92	0.5%
ken	91	0.5%
rick	91	0.5%
matt	86	0.4%
Other values (901)	19072	95.1%

Most occurring characters

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	98856	76.3%
Uppercase Letter	20461	15.8%
Space Separator	10059	7.8%
Other Punctuation	124	0.1%
Dash Punctuation	29	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	12011	12.1%
e	11836	12.0%
n	10241	10.4%
r	9530	9.6%
i	7919	8.0%
l	6494	6.6%
o	5850	5.9%
t	5435	5.5%
s	4546	4.6%
h	3857	3.9%
Other values (18)	21137	21.4%

Uppercase Letter

Value	Count	Frequency (%)
C	1830	8.9%
S	1798	8.8%
M	1749	8.5%
B	1696	8.3%
D	1325	6.5%
A	1282	6.3%
J	1134	5.5%
P	1105	5.4%
H	1005	4.9%
K	964	4.7%
Other values (16)	6573	32.1%

Space Separator

Value	Count	Frequency (%)
	10059	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	124	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	29	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119317	92.1%
Common	10212	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	12011	10.1%
e	11836	9.9%
n	10241	8.6%
r	9530	8.0%
i	7919	6.6%
l	6494	5.4%
o	5850	4.9%
t	5435	4.6%
s	4546	3.8%
h	3857	3.2%
Other values (44)	41598	34.9%

Common

Value	Count	Frequency (%)
	10059	98.5%
'	124	1.2%
-	29	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	129440	99.9%
None	89	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (44)	45519	35.2%

None

Value	Count	Frequency (%)
ö	61	68.5%
ä	23	25.8%
ü	5	5.6%

Segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Consumer	5191
Corporate	3020
Home Office	1783

Length

Max length	11
Median length	8
Mean length	8.8374024
Min length	8

Characters and Unicode

Total characters	88,321
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Corporate
4th row	Consumer
5th row	Consumer

Common Values

Value	Count	Frequency (%)
Consumer	5191	51.9%
Corporate	3020	30.2%
Home Office	1783	17.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	5191	44.1%
corporate	3020	25.6%
home	1783	15.1%
office	1783	15.1%

Most occurring characters

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	74761	84.6%
Uppercase Letter	11777	13.3%
Space Separator	1783	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	13014	17.4%
e	11777	15.8%
r	11231	15.0%
m	6974	9.3%
n	5191	6.9%
s	5191	6.9%
u	5191	6.9%
f	3566	4.8%
t	3020	4.0%
p	3020	4.0%
Other values (3)	6586	8.8%

Uppercase Letter

Value	Count	Frequency (%)
C	8211	69.7%
H	1783	15.1%
O	1783	15.1%

Space Separator

Value	Count	Frequency (%)
	1783	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	86538	98.0%
Common	1783	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	13014	15.0%
e	11777	13.6%
r	11231	13.0%
C	8211	9.5%
m	6974	8.1%
n	5191	6.0%
s	5191	6.0%
u	5191	6.0%
f	3566	4.1%
t	3020	3.5%
Other values (6)	13172	15.2%

Common

Value	Count	Frequency (%)
	1783	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	88321	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

Country
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

United States	9994

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	129,922
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	United States
2nd row	United States
3rd row	United States
4th row	United States
5th row	United States

Common Values

Value	Count	Frequency (%)
United States	9994	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
united	9994	50.0%
states	9994	50.0%

Most occurring characters

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
U	9994	7.7%
n	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	99940	76.9%
Uppercase Letter	19988	15.4%
Space Separator	9994	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	29982	30.0%
e	19988	20.0%
n	9994	10.0%
i	9994	10.0%
d	9994	10.0%
a	9994	10.0%
s	9994	10.0%

Uppercase Letter

Value	Count	Frequency (%)
U	9994	50.0%
S	9994	50.0%

Space Separator

Value	Count	Frequency (%)
	9994	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119928	92.3%
Common	9994	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	29982	25.0%
e	19988	16.7%
U	9994	8.3%
n	9994	8.3%
i	9994	8.3%
d	9994	8.3%
S	9994	8.3%
a	9994	8.3%
s	9994	8.3%

Common

Value	Count	Frequency (%)
	9994	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	129922	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
U	9994	7.7%
n	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

City
Text

Distinct	531
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Length

Max length	17
Median length	14
Mean length	9.3306984
Min length	4

Characters and Unicode

Total characters	93,251
Distinct characters	51
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70 ?
Unique (%)	0.7%

Sample

1st row	Henderson
2nd row	Henderson
3rd row	Los Angeles
4th row	Fort Lauderdale
5th row	Fort Lauderdale

Value	Count	Frequency (%)
city	994	7.0%
new	937	6.6%
york	920	6.5%
san	805	5.7%
los	747	5.2%
angeles	747	5.2%
philadelphia	537	3.8%
francisco	510	3.6%
seattle	428	3.0%
houston	377	2.6%
Other values (555)	7234	50.8%

Most occurring characters

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	74773	80.2%
Uppercase Letter	14236	15.3%
Space Separator	4242	4.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	8719	11.7%
a	7591	10.2%
o	7499	10.0%
i	6229	8.3%
n	6199	8.3%
l	5986	8.0%
s	4699	6.3%
r	4468	6.0%
t	4438	5.9%
c	2393	3.2%
Other values (16)	16552	22.1%

Uppercase Letter

Value	Count	Frequency (%)
C	2085	14.6%
S	1740	12.2%
L	1295	9.1%
A	1242	8.7%
N	1134	8.0%
P	1013	7.1%
Y	940	6.6%
F	794	5.6%
D	627	4.4%
H	617	4.3%
Other values (14)	2749	19.3%

Space Separator

Value	Count	Frequency (%)
	4242	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	89009	95.5%
Common	4242	4.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	8719	9.8%
a	7591	8.5%
o	7499	8.4%
i	6229	7.0%
n	6199	7.0%
l	5986	6.7%
s	4699	5.3%
r	4468	5.0%
t	4438	5.0%
c	2393	2.7%
Other values (40)	30788	34.6%

Common

Value	Count	Frequency (%)
	4242	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93251	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

State
Categorical

High correlation

Distinct	49
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

California	2001
New York	1128
Texas	985
Pennsylvania	587
Washington	506
Other values (44)	4787

Length

Max length	20
Median length	14
Mean length	8.4871923
Min length	4

Characters and Unicode

Total characters	84,821
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Kentucky
2nd row	Kentucky
3rd row	California
4th row	Florida
5th row	Florida

Common Values

Value	Count	Frequency (%)
California	2001	20.0%
New York	1128	11.3%
Texas	985	9.9%
Pennsylvania	587	5.9%
Washington	506	5.1%
Illinois	492	4.9%
Ohio	469	4.7%
Florida	383	3.8%
Michigan	255	2.6%
North Carolina	249	2.5%
Other values (39)	2939	29.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
california	2001	17.1%
new	1322	11.3%
york	1128	9.6%
texas	985	8.4%
pennsylvania	587	5.0%
washington	506	4.3%
illinois	492	4.2%
ohio	469	4.0%
florida	383	3.3%
carolina	291	2.5%
Other values (43)	3542	30.3%

Most occurring characters

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	71413	84.2%
Uppercase Letter	11696	13.8%
Space Separator	1712	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	10758	15.1%
i	9895	13.9%
n	8090	11.3%
o	7323	10.3%
r	5544	7.8%
e	5051	7.1%
l	4822	6.8%
s	4604	6.4%
f	2011	2.8%
h	1898	2.7%
Other values (14)	11417	16.0%

Uppercase Letter

Value	Count	Frequency (%)
C	2566	21.9%
N	1655	14.2%
T	1168	10.0%
Y	1128	9.6%
M	763	6.5%
I	748	6.4%
O	659	5.6%
W	621	5.3%
P	587	5.0%
F	383	3.3%
Other values (11)	1418	12.1%

Space Separator

Value	Count	Frequency (%)
	1712	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	83109	98.0%
Common	1712	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	10758	12.9%
i	9895	11.9%
n	8090	9.7%
o	7323	8.8%
r	5544	6.7%
e	5051	6.1%
l	4822	5.8%
s	4604	5.5%
C	2566	3.1%
f	2011	2.4%
Other values (35)	22445	27.0%

Common

Value	Count	Frequency (%)
	1712	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84821	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Postal Code
Real number (ℝ)

High correlation

Distinct	631
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55190.379

Minimum	1040
Maximum	99301
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1040
5-th percentile	10009
Q1	23223
median	56430.5
Q3	90008
95-th percentile	98006
Maximum	99301
Range	98261
Interquartile range (IQR)	66785

Descriptive statistics

Standard deviation	32063.693
Coefficient of variation (CV)	0.58096526
Kurtosis	-1.4930202
Mean	55190.379
Median Absolute Deviation (MAD)	33573.5
Skewness	-0.12852552
Sum	5.5157265 × 10⁸
Variance	1.0280804 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10035	263	2.6%
10024	230	2.3%
10009	229	2.3%
94122	203	2.0%
10011	193	1.9%
94110	166	1.7%
98105	165	1.7%
19134	160	1.6%
98103	151	1.5%
90049	151	1.5%
Other values (621)	8083	80.9%

Value	Count	Frequency (%)
1040	1	< 0.1%
1453	6	0.1%
1752	2	< 0.1%
1810	4	< 0.1%
1841	33	0.3%
1852	16	0.2%
1915	3	< 0.1%
2038	17	0.2%
2138	6	0.1%
2148	3	< 0.1%

Value	Count	Frequency (%)
99301	6	0.1%
99207	7	0.1%
98661	5	0.1%
98632	3	< 0.1%
98502	5	0.1%
98270	2	< 0.1%
98226	3	< 0.1%
98208	1	< 0.1%
98198	7	0.1%
98115	112	1.1%

Region
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

West	3203
East	2848
Central	2323
South	1620

Length

Max length	7
Median length	4
Mean length	4.8594156
Min length	4

Characters and Unicode

Total characters	48,565
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	South
2nd row	South
3rd row	West
4th row	South
5th row	South

Common Values

Value	Count	Frequency (%)
West	3203	32.0%
East	2848	28.5%
Central	2323	23.2%
South	1620	16.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
west	3203	32.0%
east	2848	28.5%
central	2323	23.2%
south	1620	16.2%

Most occurring characters

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	38571	79.4%
Uppercase Letter	9994	20.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	9994	25.9%
s	6051	15.7%
e	5526	14.3%
a	5171	13.4%
n	2323	6.0%
r	2323	6.0%
l	2323	6.0%
o	1620	4.2%
u	1620	4.2%
h	1620	4.2%

Uppercase Letter

Value	Count	Frequency (%)
W	3203	32.0%
E	2848	28.5%
C	2323	23.2%
S	1620	16.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	48565	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48565	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Product ID
Text

Distinct	1862
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	149,910
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	91 ?
Unique (%)	0.9%

Sample

1st row	FUR-BO-10001798
2nd row	FUR-CH-10000454
3rd row	OFF-LA-10000240
4th row	FUR-TA-10000577
5th row	OFF-ST-10000760

Value	Count	Frequency (%)
off-pa-10001970	19	0.2%
tec-ac-10003832	18	0.2%
fur-fu-10004270	16	0.2%
fur-ch-10001146	15	0.2%
tec-ac-10003628	15	0.2%
fur-ch-10002647	15	0.2%
tec-ac-10002049	15	0.2%
off-pa-10002377	14	0.1%
fur-ch-10003774	14	0.1%
off-bi-10002026	14	0.1%
Other values (1852)	9839	98.4%

Most occurring characters

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79952	53.3%
Uppercase Letter	49970	33.3%
Dash Punctuation	19988	13.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	15347	30.7%
O	6322	12.7%
A	4422	8.8%
C	3307	6.6%
U	3268	6.5%
T	3012	6.0%
R	2917	5.8%
P	2725	5.5%
E	2101	4.2%
B	1751	3.5%
Other values (6)	4798	9.6%

Decimal Number

Value	Count	Frequency (%)
0	35052	43.8%
1	14995	18.8%
2	4862	6.1%
4	4831	6.0%
3	4805	6.0%
5	3401	4.3%
7	3103	3.9%
9	3051	3.8%
6	2999	3.8%
8	2853	3.6%

Dash Punctuation

Value	Count	Frequency (%)
-	19988	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	99940	66.7%
Latin	49970	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	15347	30.7%
O	6322	12.7%
A	4422	8.8%
C	3307	6.6%
U	3268	6.5%
T	3012	6.0%
R	2917	5.8%
P	2725	5.5%
E	2101	4.2%
B	1751	3.5%
Other values (6)	4798	9.6%

Common

Value	Count	Frequency (%)
0	35052	35.1%
-	19988	20.0%
1	14995	15.0%
2	4862	4.9%
4	4831	4.8%
3	4805	4.8%
5	3401	3.4%
7	3103	3.1%
9	3051	3.1%
6	2999	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	149910	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Category
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Office Supplies	6026
Furniture	2121
Technology	1847

Length

Max length	15
Median length	15
Mean length	12.802582
Min length	9

Characters and Unicode

Total characters	127,949
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Furniture
2nd row	Furniture
3rd row	Office Supplies
4th row	Furniture
5th row	Office Supplies

Common Values

Value	Count	Frequency (%)
Office Supplies	6026	60.3%
Furniture	2121	21.2%
Technology	1847	18.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
office	6026	37.6%
supplies	6026	37.6%
furniture	2121	13.2%
technology	1847	11.5%

Most occurring characters

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	105903	82.8%
Uppercase Letter	16020	12.5%
Space Separator	6026	4.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	16020	15.1%
i	14173	13.4%
p	12052	11.4%
f	12052	11.4%
u	10268	9.7%
c	7873	7.4%
l	7873	7.4%
s	6026	5.7%
r	4242	4.0%
n	3968	3.7%
Other values (5)	11356	10.7%

Uppercase Letter

Value	Count	Frequency (%)
O	6026	37.6%
S	6026	37.6%
F	2121	13.2%
T	1847	11.5%

Space Separator

Value	Count	Frequency (%)
	6026	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	121923	95.3%
Common	6026	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	16020	13.1%
i	14173	11.6%
p	12052	9.9%
f	12052	9.9%
u	10268	8.4%
c	7873	6.5%
l	7873	6.5%
O	6026	4.9%
s	6026	4.9%
S	6026	4.9%
Other values (9)	23534	19.3%

Common

Value	Count	Frequency (%)
	6026	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	127949	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

Sub-Category
Categorical

High correlation

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Binders	1523
Paper	1370
Furnishings	957
Phones	889
Storage	846
Other values (12)	4409

Length

Max length	11
Median length	9
Mean length	7.191715
Min length	3

Characters and Unicode

Total characters	71,874
Distinct characters	28
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bookcases
2nd row	Chairs
3rd row	Labels
4th row	Tables
5th row	Storage

Common Values

Value	Count	Frequency (%)
Binders	1523	15.2%
Paper	1370	13.7%
Furnishings	957	9.6%
Phones	889	8.9%
Storage	846	8.5%
Art	796	8.0%
Accessories	775	7.8%
Chairs	617	6.2%
Appliances	466	4.7%
Labels	364	3.6%
Other values (7)	1391	13.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
binders	1523	15.2%
paper	1370	13.7%
furnishings	957	9.6%
phones	889	8.9%
storage	846	8.5%
art	796	8.0%
accessories	775	7.8%
chairs	617	6.2%
appliances	466	4.7%
labels	364	3.6%
Other values (7)	1391	13.9%

Most occurring characters

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	61880	86.1%
Uppercase Letter	9994	13.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	9934	16.1%
e	8870	14.3%
r	7169	11.6%
i	5668	9.2%
n	5378	8.7%
a	4542	7.3%
o	3288	5.3%
p	3004	4.9%
h	2578	4.2%
c	2359	3.8%
Other values (8)	9090	14.7%

Uppercase Letter

Value	Count	Frequency (%)
P	2259	22.6%
A	2037	20.4%
B	1751	17.5%
F	1174	11.7%
S	1036	10.4%
C	685	6.9%
L	364	3.6%
T	319	3.2%
E	254	2.5%
M	115	1.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	71874	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	71874	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Product Name
Text

Distinct	1850
Distinct (%)	18.5%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Length

Max length	127
Median length	78
Mean length	36.91605
Min length	5

Characters and Unicode

Total characters	368,939
Distinct characters	85
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	91 ?
Unique (%)	0.9%

Sample

1st row	Bush Somerset Collection Bookcase
2nd row	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back
3rd row	Self-Adhesive Address Labels for Typewriters by Universal
4th row	Bretford CR4500 Series Slim Rectangular Table
5th row	Eldon Fold 'N Roll Cart System

Value	Count	Frequency (%)
xerox	865	1.5%
x	701	1.3%
	599	1.1%
with	599	1.1%
avery	557	1.0%
for	539	1.0%
binders	524	0.9%
chair	479	0.9%
black	426	0.8%
phone	374	0.7%
Other values (2798)	50371	89.9%

Most occurring characters

Value	Count	Frequency (%)
	45670	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (75)	150106	40.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	238253	64.6%
Uppercase Letter	56270	15.3%
Space Separator	46097	12.5%
Decimal Number	17981	4.9%
Other Punctuation	7152	1.9%
Dash Punctuation	2940	0.8%
Control	86	< 0.1%
Close Punctuation	60	< 0.1%
Open Punctuation	60	< 0.1%
Math Symbol	35	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	33538	14.1%
r	20791	8.7%
o	19902	8.4%
a	19064	8.0%
i	18648	7.8%
l	16365	6.9%
n	15622	6.6%
s	14683	6.2%
t	14550	6.1%
c	8924	3.7%
Other values (18)	56166	23.6%

Uppercase Letter

Value	Count	Frequency (%)
S	6281	11.2%
C	6007	10.7%
B	5530	9.8%
P	4918	8.7%
A	2948	5.2%
D	2941	5.2%
M	2870	5.1%
T	2616	4.6%
F	2510	4.5%
L	2284	4.1%
Other values (16)	17365	30.9%

Other Punctuation

Value	Count	Frequency (%)
,	3120	43.6%
/	1561	21.8%
"	1300	18.2%
.	463	6.5%
&	287	4.0%
'	257	3.6%
#	90	1.3%
%	45	0.6%
*	9	0.1%
!	9	0.1%
Other values (2)	11	0.2%

Decimal Number

Value	Count	Frequency (%)
1	3783	21.0%
0	2921	16.2%
2	2270	12.6%
4	1725	9.6%
3	1530	8.5%
5	1443	8.0%
8	1254	7.0%
9	1234	6.9%
6	941	5.2%
7	880	4.9%

Space Separator

Value	Count	Frequency (%)
	45670	99.1%
	427	0.9%

Control

Value	Count	Frequency (%)
	67	77.9%
	19	22.1%

Dash Punctuation

Value	Count	Frequency (%)
-	2940	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	60	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	60	100.0%

Math Symbol

Value	Count	Frequency (%)
+	35	100.0%

Other Number

Value	Count	Frequency (%)
¾	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	294523	79.8%
Common	74416	20.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	33538	11.4%
r	20791	7.1%
o	19902	6.8%
a	19064	6.5%
i	18648	6.3%
l	16365	5.6%
n	15622	5.3%
s	14683	5.0%
t	14550	4.9%
c	8924	3.0%
Other values (44)	112436	38.2%

Common

Value	Count	Frequency (%)
	45670	61.4%
1	3783	5.1%
,	3120	4.2%
-	2940	4.0%
0	2921	3.9%
2	2270	3.1%
4	1725	2.3%
/	1561	2.1%
3	1530	2.1%
5	1443	1.9%
Other values (21)	7453	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	368404	99.9%
None	535	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	45670	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (69)	149571	40.6%

None

Value	Count	Frequency (%)
	427	79.8%
	67	12.5%
	19	3.6%
é	14	2.6%
¾	5	0.9%
à	3	0.6%

Sales
Real number (ℝ)

High correlation

Distinct	5825
Distinct (%)	58.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	229.858

Minimum	0.444
Maximum	22638.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0.444
5-th percentile	4.98
Q1	17.28
median	54.49
Q3	209.94
95-th percentile	956.98425
Maximum	22638.48
Range	22638.036
Interquartile range (IQR)	192.66

Descriptive statistics

Standard deviation	623.2451
Coefficient of variation (CV)	2.7114353
Kurtosis	305.31175
Mean	229.858
Median Absolute Deviation (MAD)	45.406
Skewness	12.972752
Sum	2297200.9
Variance	388434.46
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.96	56	0.6%
19.44	39	0.4%
15.552	39	0.4%
25.92	36	0.4%
10.368	36	0.4%
32.4	28	0.3%
17.94	21	0.2%
6.48	21	0.2%
20.736	19	0.2%
14.94	17	0.2%
Other values (5815)	9682	96.9%

Value	Count	Frequency (%)
0.444	1	< 0.1%
0.556	1	< 0.1%
0.836	1	< 0.1%
0.852	1	< 0.1%
0.876	1	< 0.1%
0.898	1	< 0.1%
0.984	1	< 0.1%
0.99	1	< 0.1%
1.044	1	< 0.1%
1.08	3	< 0.1%

Value	Count	Frequency (%)
22638.48	1	< 0.1%
17499.95	1	< 0.1%
13999.96	1	< 0.1%
11199.968	1	< 0.1%
10499.97	1	< 0.1%
9892.74	1	< 0.1%
9449.95	1	< 0.1%
9099.93	1	< 0.1%
8749.95	1	< 0.1%
8399.976	1	< 0.1%

Quantity
Real number (ℝ)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.7895737

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	8
Maximum	14
Range	13
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2251097
Coefficient of variation (CV)	0.58716622
Kurtosis	1.9918894
Mean	3.7895737
Median Absolute Deviation (MAD)	1
Skewness	1.2785448
Sum	37873
Variance	4.9511131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	2409	24.1%
2	2402	24.0%
5	1230	12.3%
4	1191	11.9%
1	899	9.0%
7	606	6.1%
6	572	5.7%
9	258	2.6%
8	257	2.6%
10	57	0.6%
Other values (4)	113	1.1%

Value	Count	Frequency (%)
1	899	9.0%
2	2402	24.0%
3	2409	24.1%
4	1191	11.9%
5	1230	12.3%
6	572	5.7%
7	606	6.1%
8	257	2.6%
9	258	2.6%
10	57	0.6%

Value	Count	Frequency (%)
14	29	0.3%
13	27	0.3%
12	23	0.2%
11	34	0.3%
10	57	0.6%
9	258	2.6%
8	257	2.6%
7	606	6.1%
6	572	5.7%
5	1230	12.3%

Discount
Real number (ℝ)

High correlation Zeros

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15620272

Minimum	0
Maximum	0.8
Zeros	4798
Zeros (%)	48.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.2
Q3	0.2
95-th percentile	0.7
Maximum	0.8
Range	0.8
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.20645197
Coefficient of variation (CV)	1.3216925
Kurtosis	2.4095461
Mean	0.15620272
Median Absolute Deviation (MAD)	0.2
Skewness	1.6842947
Sum	1561.09
Variance	0.042622415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	4798	48.0%
0.2	3657	36.6%
0.7	418	4.2%
0.8	300	3.0%
0.3	227	2.3%
0.4	206	2.1%
0.6	138	1.4%
0.1	94	0.9%
0.5	66	0.7%
0.15	52	0.5%
Other values (2)	38	0.4%

Value	Count	Frequency (%)
0	4798	48.0%
0.1	94	0.9%
0.15	52	0.5%
0.2	3657	36.6%
0.3	227	2.3%
0.32	27	0.3%
0.4	206	2.1%
0.45	11	0.1%
0.5	66	0.7%
0.6	138	1.4%

Value	Count	Frequency (%)
0.8	300	3.0%
0.7	418	4.2%
0.6	138	1.4%
0.5	66	0.7%
0.45	11	0.1%
0.4	206	2.1%
0.32	27	0.3%
0.3	227	2.3%
0.2	3657	36.6%
0.15	52	0.5%

Profit
Real number (ℝ)

High correlation

Distinct	7287
Distinct (%)	72.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.656896

Minimum	-6599.978
Maximum	8399.976
Zeros	65
Zeros (%)	0.7%
Negative	1871
Negative (%)	18.7%
Memory size	78.2 KiB

Quantile statistics

Minimum	-6599.978
5-th percentile	-53.03092
Q1	1.72875
median	8.6665
Q3	29.364
95-th percentile	168.4704
Maximum	8399.976
Range	14999.954
Interquartile range (IQR)	27.63525

Descriptive statistics

Standard deviation	234.26011
Coefficient of variation (CV)	8.1746504
Kurtosis	397.18851
Mean	28.656896
Median Absolute Deviation (MAD)	10.77855
Skewness	7.5614316
Sum	286397.02
Variance	54877.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65	0.7%
6.2208	43	0.4%
9.3312	38	0.4%
5.4432	32	0.3%
3.6288	32	0.3%
15.552	26	0.3%
12.4416	21	0.2%
7.2576	19	0.2%
3.1104	18	0.2%
9.072	11	0.1%
Other values (7277)	9689	96.9%

Value	Count	Frequency (%)
-6599.978	1	< 0.1%
-3839.9904	1	< 0.1%
-3701.8928	1	< 0.1%
-3399.98	1	< 0.1%
-2929.4845	1	< 0.1%
-2639.9912	1	< 0.1%
-2287.782	1	< 0.1%
-1862.3124	1	< 0.1%
-1850.9464	1	< 0.1%
-1811.0784	1	< 0.1%

Value	Count	Frequency (%)
8399.976	1	< 0.1%
6719.9808	1	< 0.1%
5039.9856	1	< 0.1%
4946.37	1	< 0.1%
4630.4755	1	< 0.1%
3919.9888	1	< 0.1%
3177.475	1	< 0.1%
2799.984	1	< 0.1%
2591.9568	1	< 0.1%
2504.2216	1	< 0.1%

Interactions

Correlations

	Category	Discount	Postal Code	Profit	Quantity	Region	Row ID	Sales	Segment	Ship Mode	State	Sub-Category
Category	1.000	0.377	0.000	0.056	0.000	0.000	0.008	0.072	0.000	0.000	0.019	0.999
Discount	0.377	1.000	0.053	-0.543	-0.001	0.294	0.013	-0.057	0.005	0.027	0.354	0.353
Postal Code	0.000	0.053	1.000	-0.005	0.014	0.921	0.011	-0.002	0.035	0.038	0.968	0.000
Profit	0.056	-0.543	-0.005	1.000	0.234	0.021	-0.011	0.518	0.000	0.005	0.017	0.130
Quantity	0.000	-0.001	0.014	0.234	1.000	0.000	-0.002	0.327	0.012	0.000	0.004	0.000
Region	0.000	0.294	0.921	0.021	0.000	1.000	0.038	0.000	0.000	0.022	0.998	0.000
Row ID	0.008	0.013	0.011	-0.011	-0.002	0.038	1.000	-0.001	0.030	0.050	0.102	0.000
Sales	0.072	-0.057	-0.002	0.518	0.327	0.000	-0.001	1.000	0.002	0.000	0.000	0.142
Segment	0.000	0.005	0.035	0.000	0.012	0.000	0.030	0.002	1.000	0.033	0.090	0.000
Ship Mode	0.000	0.027	0.038	0.005	0.000	0.022	0.050	0.000	0.033	1.000	0.096	0.007
State	0.019	0.354	0.968	0.017	0.004	0.998	0.102	0.000	0.090	0.096	1.000	0.000
Sub-Category	0.999	0.353	0.000	0.130	0.000	0.000	0.000	0.142	0.000	0.007	0.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	Country	City	State	Postal Code	Region	Product ID	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit
0	1	CA-2016-152156	2016-11-08	2016-11-11	Second Class	CG-12520	Claire Gute	Consumer	United States	Henderson	Kentucky	42420	South	FUR-BO-10001798	Furniture	Bookcases	Bush Somerset Collection Bookcase	261.9600	2	0.00	41.9136
1	2	CA-2016-152156	2016-11-08	2016-11-11	Second Class	CG-12520	Claire Gute	Consumer	United States	Henderson	Kentucky	42420	South	FUR-CH-10000454	Furniture	Chairs	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back	731.9400	3	0.00	219.5820
2	3	CA-2016-138688	2016-06-12	2016-06-16	Second Class	DV-13045	Darrin Van Huff	Corporate	United States	Los Angeles	California	90036	West	OFF-LA-10000240	Office Supplies	Labels	Self-Adhesive Address Labels for Typewriters by Universal	14.6200	2	0.00	6.8714
3	4	US-2015-108966	2015-10-11	2015-10-18	Standard Class	SO-20335	Sean O'Donnell	Consumer	United States	Fort Lauderdale	Florida	33311	South	FUR-TA-10000577	Furniture	Tables	Bretford CR4500 Series Slim Rectangular Table	957.5775	5	0.45	-383.0310
4	5	US-2015-108966	2015-10-11	2015-10-18	Standard Class	SO-20335	Sean O'Donnell	Consumer	United States	Fort Lauderdale	Florida	33311	South	OFF-ST-10000760	Office Supplies	Storage	Eldon Fold 'N Roll Cart System	22.3680	2	0.20	2.5164
5	6	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	FUR-FU-10001487	Furniture	Furnishings	Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood	48.8600	7	0.00	14.1694
6	7	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	OFF-AR-10002833	Office Supplies	Art	Newell 322	7.2800	4	0.00	1.9656
7	8	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	TEC-PH-10002275	Technology	Phones	Mitel 5320 IP Phone VoIP phone	907.1520	6	0.20	90.7152
8	9	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	OFF-BI-10003910	Office Supplies	Binders	DXL Angle-View Binders with Locking Rings by Samsill	18.5040	3	0.20	5.7825
9	10	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	OFF-AP-10002892	Office Supplies	Appliances	Belkin F5C206VTEL 6 Outlet Surge	114.9000	5	0.00	34.4700

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	Country	City	State	Postal Code	Region	Product ID	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit
9984	9985	CA-2015-100251	2015-05-17	2015-05-23	Standard Class	DV-13465	Dianna Vittorini	Consumer	United States	Long Beach	New York	11561	East	OFF-LA-10003766	Office Supplies	Labels	Self-Adhesive Removable Labels	31.500	10	0.0	15.1200
9985	9986	CA-2015-100251	2015-05-17	2015-05-23	Standard Class	DV-13465	Dianna Vittorini	Consumer	United States	Long Beach	New York	11561	East	OFF-SU-10000898	Office Supplies	Supplies	Acme Hot Forged Carbon Steel Scissors with Nickel-Plated Handles, 3 7/8" Cut, 8"L	55.600	4	0.0	16.1240
9986	9987	CA-2016-125794	2016-09-29	2016-10-03	Standard Class	ML-17410	Maris LaWare	Consumer	United States	Los Angeles	California	90008	West	TEC-AC-10003399	Technology	Accessories	Memorex Mini Travel Drive 64 GB USB 2.0 Flash Drive	36.240	1	0.0	15.2208
9987	9988	CA-2017-163629	2017-11-17	2017-11-21	Standard Class	RA-19885	Ruben Ausman	Corporate	United States	Athens	Georgia	30605	South	TEC-AC-10001539	Technology	Accessories	Logitech G430 Surround Sound Gaming Headset with Dolby 7.1 Technology	79.990	1	0.0	28.7964
9988	9989	CA-2017-163629	2017-11-17	2017-11-21	Standard Class	RA-19885	Ruben Ausman	Corporate	United States	Athens	Georgia	30605	South	TEC-PH-10004006	Technology	Phones	Panasonic KX - TS880B Telephone	206.100	5	0.0	55.6470
9989	9990	CA-2014-110422	2014-01-21	2014-01-23	Second Class	TB-21400	Tom Boeckenhauer	Consumer	United States	Miami	Florida	33180	South	FUR-FU-10001889	Furniture	Furnishings	Ultra Door Pull Handle	25.248	3	0.2	4.1028
9990	9991	CA-2017-121258	2017-02-26	2017-03-03	Standard Class	DB-13060	Dave Brooks	Consumer	United States	Costa Mesa	California	92627	West	FUR-FU-10000747	Furniture	Furnishings	Tenex B1-RE Series Chair Mats for Low Pile Carpets	91.960	2	0.0	15.6332
9991	9992	CA-2017-121258	2017-02-26	2017-03-03	Standard Class	DB-13060	Dave Brooks	Consumer	United States	Costa Mesa	California	92627	West	TEC-PH-10003645	Technology	Phones	Aastra 57i VoIP phone	258.576	2	0.2	19.3932
9992	9993	CA-2017-121258	2017-02-26	2017-03-03	Standard Class	DB-13060	Dave Brooks	Consumer	United States	Costa Mesa	California	92627	West	OFF-PA-10004041	Office Supplies	Paper	It's Hot Message Books with Stickers, 2 3/4" x 5"	29.600	4	0.0	13.3200
9993	9994	CA-2017-119914	2017-05-04	2017-05-09	Second Class	CC-12220	Chris Cortes	Consumer	United States	Westminster	California	92683	West	OFF-AP-10002684	Office Supplies	Appliances	Acco 7-Outlet Masterpiece Power Center, Wihtout Fax/Phone Line Protection	243.160	2	0.0	72.9480

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)